Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TillID (FK)(PK) | The unique identifier for the TENDER RESPOSITORY. | ID_RPSTY_TND | Identity | integer | Till(AS_TL) |
TenderTypeCode (FK)(PK) | A code which uniquely identifies the type of tender for which the drawer limit is being imposed. e.g. US Cash, Cheques, CreditCard, etc. | TY_TND | Code | varchar(20) | Tender(AS_TND) |
TimeGroupID (FK)(PK) | A unique identifier for a set of consecutive hours on a set of days of the week during which the given DrawerLimitRule takes effect. e.g. 10am - 2pm Mon, Wed and Fri. | ID_GP_TM | Identity | integer | TimeGroup(CO_GP_TM) |
EffectiveDateTime (PK) | The date and time from which the DrawerLimitRule takes effect. | DC_EF | EffectiveDateTime | datetime | |
ExpirationDateTime | The date and time after which the DrawerLimitRule no longer takes effect. | DC_EP | ExpirationDateTime | datetime | |
TillLimitRuleID (FK) | A unique system assigned identifier for the Drawer Limit Rule. | ID_TL_LM_RU | Identity | integer | TillLimitRule(RU_LM_TL) |